IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MachineCluster]') AND type in (N'U'))
BEGIN
     DROP TABLE [dbo].[MachineCluster]
END
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[MachineCluster](
     [ClusterMachineId]   [int]      NOT NULL,
     [MemberMachineId]    [int]      NOT NULL,
     [PackageExecutionId] [bigint]   NOT NULL,
     [LastModDt]          [datetime] NOT NULL CONSTRAINT [DF_MachineCluster_LastModDt] DEFAULT (getdate()),
     CONSTRAINT [PK_MachineCluster] PRIMARY KEY CLUSTERED ( [ClusterMachineId] ASC, [MemberMachineId] ASC )
) ON [PRIMARY]
GO

SET ANSI_PADDING OFF
GO

